[dbo].[BAEUpdateLoginTime]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEUpdateLoginTime

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@userID	varchar(10)	10

SQL Script

create procedure [dbo].[BAEUpdateLoginTime] @userID varchar(10) as
UPDATE Name_Security
    SET PREVIOUS_LOGIN = LAST_LOGIN
    WHERE ID = @userID;

    UPDATE Name_Security
    SET LAST_LOGIN = GETDATE()
    WHERE ID = @userID;

GO

Uses

[dbo].[Name_Security]
dbo